Senior Management: Microsoft Excel Data Analysis and Dashboard Reporting [Intermediate] Online Training

Schedules	:	January 14-15, 2021 ,
Location	:	Johor Bahru, Johor	Country	:	Malaysia
Scheme	:	SBL
Contact Person	:	Pn. Astri, En. Omar, Ms. Jessica
Contact Email	:	astri@fmm.org.my, omar@fmm.org.my, jessica@fmm.org.my	Contact Tel	:	+607 - 357 7613

	Registration Fee (Per Participant)

No. of Participants	Member	Non Member
1	RM 1,000.00	RM 1,000.00

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
The Excel Analysis and Dashboard Reporting course covers some of the most popular data analysis Excel functions and Dashboard tools, including;
• VLOOKUP() Function for Looking up Information
• INDEX()/MATCH() Functions a Powerful Alternative to VLOOKUP
• TEXT() Function for Formatting
• CHOOSE() for Ultimate Flexibility in Presenting Data
• Advanced Filtering
• Summarizing Data with PivotTables and Pivot Charts

select

In-house Programmes - Customised, cost effective courses at your own convenience